Using Reference Models for Data Warehouse Metadata Management
نویسندگان
چکیده
Based on experience from applying the Common Warehouse Metamodel to metadata management at a large Swiss bank, the applicability of metadata reference models in complex application domains is analyzed. In order to explain the context of the case, the state-of-the-art of the Common Warehouse Metamodel and its application for data warehouse management are summarized. Based on the project experience documented in this paper, benefits of the reference model approach are described and recommendations for future developments of the Common Warehouse Metamodel are proposed.
منابع مشابه
Data warehouse process management
− Previous research has provided metadata models that enable the capturing of the static components of a data warehouse architecture, along with information on different quality factors over these components. This paper complements this work with the modeling of the dynamic parts of the data warehouse. The proposed metamodel of data warehouse operational processes is capable of modeling complex...
متن کاملTowards Implementing Total Data Quality Management in a Data Warehouse
Poor quality of data in a warehouse adversely impacts the usability of the warehouse and managing data quality in a warehouse is very important. In this article we describe a framework for managing data quality in a data warehouse. This framework is of interest to both academics and practitioners as it offers an intuitive approach for not just managing data quality in a data warehouse but also ...
متن کاملThe Process of Metadata Modeling in Industrial Data Warehouse Environments
Modern application landscapes and especially huge enterprise applications, like data warehouses, used for decision support or other analyzing purposes get more and more complex. To manage, use and maintain these systems the need for metadata management has increased. In consequence of new tasks being identified by new groups of data warehouse users, the role of metadata management implies more ...
متن کاملAn ETL Metadata Model for Data Warehousing
Metadata is essential for understanding information stored in data warehouses. It helps increase levels of adoption and usage of data warehouse data by knowledge workers and decision makers. A metadata model is important to the implementation of a data warehouse; the lack of a metadata model can lead to quality concerns about the data warehouse. A highly successful data warehouse implementation...
متن کاملMetadata Management for Data Warehouse Projects
Metadata management has been identified as one of the major critical success factor in data warehousing projects, but the industrialization process of metadata management did not yet reach a satisfying level of maturity from both a methodological and a technological point of view; therefore every project has to build its own metadata management system following the methodology that better fits ...
متن کامل